Skip Headers

SQL*Plus® User's Guide and Reference Release 10.2 Part Number B14357-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DISCONNECT

Syntax

DISC[ONNECT]

Commits pending changes to the database and logs the current username out of Oracle Database, but does not exit SQL*Plus.

Usage

Use DISCONNECT within a script to prevent user access to the database when you want to log the user out of Oracle Database but have the user remain in SQL*Plus. In SQL*Plus command-line, use EXIT or QUIT to log out of Oracle Database and return control to your computer's operating system. In iSQL*Plus, click the Logout button to log out of Oracle Database.

Examples

Your script might begin with a CONNECT command and end with a DISCONNECT, as shown later.

    CONNECT HR
    SELECT LAST_NAME, DEPARTMENT_NAME FROM EMP_DETAILS_VIEW;
    DISCONNECT
    SET INSTANCE FIN2
    CONNECT HR2